import pymysql
from settings import dbParmas
dbParmas['db'] = 'bbs'
conn = pymysql.Connect(**dbParmas)
sql = "create table user(uid int primary key auto_increment ,username varchar(100) unique,usertype enum('0','1') default '0',password varchar(100),regtime datetime,email varchar(100))"
cursor = conn.cursor()
cursor.execute(sql)
cursor.close()
conn.close()